<html>
<head>
<title>Docs For Class simplesql</title>
<link rel="stylesheet" type="text/css" href="../media/style.css">

<style>
.php {
	padding: 1em;
}
/* This will not be executed by IE, so now we have a fix! */
*[class="php-src"], *[class="php"], *[class="listing"] {
	line-height:    0px;
}

body
{
  color:              #000000;
  background-color:   #ffffff;
  background-image:   url("background.png");
  background-repeat:  repeat-y;
  font-family:        tahoma, verdana, arial, sans-serif;
  font-size:          10pt;
  margin:             0;
  padding:            0;
}

a
{
  color:              #000099;
  background-color:   transparent;
  text-decoration:    none;
}

a:hover
{
  text-decoration:    underline;
}

a.menu
{
  color:              #ffffff;
  background-color:   transparent;
}

td
{
  font-size:          10pt;
}

td.header_top
{
  color:              #ffffff;
  background-color:   #9999cc;
  font-size:          16pt;
  font-weight:        bold;
  text-align:         right;
  padding:            10px;
}

td.header_line
{
  color:              #ffffff;
  background-color:   #333366;
}

td.header_menu
{
  color:              #ffffff;
  background-color:   #666699;
  font-size:          8pt;
  text-align:         right;
  padding:            2px;
  padding-right:      5px;
}

td.menu
{
  padding:            2px;
  padding-left:       5px;
}

td.code_border
{
  color:              #000000;
  background-color:   #c0c0c0;
}

td.code
{
  color:              #000000;
  background-color:   #f0f0f0;
}

td.type
{
  font-style:         italic;
}

div.credit
{
  font-size:          8pt;
  text-align:         center;
}

div.package
{
  padding-left:       5px;
}

div.tags
{
  padding-left:       15px;
}

div.function
{
  padding-left:       15px;
}

div.top
{
  font-size:          8pt;
}

div.warning
{
  color:              #ff0000;
  background-color:   transparent;
}

div.description
{
  padding-left:       15px;
}

hr
{
  height:             1px;
  border-style:       solid;
  border-color:       #c0c0c0;
  margin-top:         10px;
  margin-bottom:      10px;
}

span.smalllinenumber
{
  font-size:          8pt;
}

ul {
	margin-left:		0px;
	padding-left:		8px;
}
/* Syntax highlighting */

.src-code { background-color: #f5f5f5; border: 1px solid #ccc9a4; padding: 0px; margin : 0px}
/*.src-code pre {	}*/

.src-comm { color: green; }
.src-id {  }
.src-inc { color: #0000FF; }
.src-key { color: #0000FF; }
.src-num { color: #CC0000; }
.src-str { color: #66cccc; }
.src-sym { font-weight: bold; }
.src-var { }

.src-php { font-weight: bold; }

.src-doc { color: #009999 }
.src-doc-close-template { color: #0000FF }
.src-doc-coretag { color: #0099FF; font-weight: bold }
.src-doc-inlinetag { color: #0099FF }
.src-doc-internal { color: #6699cc }
.src-doc-tag { color: #0080CC }
.src-doc-template { color: #0000FF }
.src-doc-type { font-style: italic }
.src-doc-var { font-style: italic }

.tute-tag { color: #009999 }
.tute-attribute-name { color: #0000FF }
.tute-attribute-value { color: #0099FF }
.tute-entity { font-weight: bold; }
.tute-comment { font-style: italic }
.tute-inline-tag { color: #636311; font-weight: bold }

/* tutorial */

.authors {  }
.author { font-style: italic; font-weight: bold }
.author-blurb { margin: .5em 0em .5em 2em; font-size: 85%; font-weight: normal; font-style: normal }
.example { border: 1px dashed #999999; background-color: #EEEEEE; padding: .5em; }
.listing { border: 1px dashed #999999; background-color: #EEEEEE; padding: .5em; white-space: nowrap; }
.release-info { font-size: 85%; font-style: italic; margin: 1em 0em }
.ref-title-box {  }
.ref-title {  }
.ref-purpose { font-style: italic; color: #666666 }
.ref-synopsis {  }
.title { font-weight: bold; margin: 1em 0em 0em 0em; padding: .25em; border: 2px solid #999999; background-color: #9999CC  }
.cmd-synopsis { margin: 1em 0em }
.cmd-title { font-weight: bold }
.toc { margin-left: 2em; padding-left: 0em }


</style>

</head>
<body>

<table border="0" cellspacing="0" cellpadding="0" height="48" width="100%">
  <tr>
    <td class="header_top">SimpleSQL</td>
  </tr>
  <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
  <tr>
    <td class="header_menu">
		  [ <a href="http://www.protonage.net" class="menu">Protonage.Net</a> ]
    </td>
  </tr>
  <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
</table>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td>
      <table cellpadding="10" cellspacing="0" width="100%" border="0"><tr><td valign="top">

<h1>Class: simplesql</h1>
Source Location: /simplesql.class.php5<br /><br />


<table width="100%" border="0">
<tr><td valign="top">

<h3><a href="#class_details">Class Overview</a></h3>
<pre></pre><br />
<div class="description">
This is PHP 5 version of a previously released MySQL database wrapper class.<br />
<br />
It has many features that will simplify database tasks of executing SQL queries and retrieving its results. The main feature functions include: fetch_col, fetch_row, fetch_search, fetch, insert, update, delete.<br />
<br />
Simple SQL PHP 5 also provides extensive logging features. Optionally it can log every event or error to a session in a text file. It may also serialize the whole log data array.<br />
<br />
The log file can later on be used to optimize database structures and have complete control over past sessions of the class.
</div><br /><br />







</td>
</tr>
<tr>
<td valign="top">
<h3><a href="#class_consts">Constants</a></h3>
<ul>
    <li><a href="../SimpleSQL/simplesql.html#constDATE_FORMAT">DATE_FORMAT</a></li>
    <li><a href="../SimpleSQL/simplesql.html#constLOG_PATH">LOG_PATH</a></li>
    <li><a href="../SimpleSQL/simplesql.html#constMAX_SIZE">MAX_SIZE</a></li>
    <li><a href="../SimpleSQL/simplesql.html#constVERSION">VERSION</a></li>
  </ul>
</td>
</tr><tr>
<td valign="top">
<h3><a href="#class_methods">Methods</a></h3>
<ul>
    <li><a href="../SimpleSQL/simplesql.html#methodage">age</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodconnect">connect</a></li>
    <li><a href="../SimpleSQL/simplesql.html#method__construct">__construct</a></li>
    <li><a href="../SimpleSQL/simplesql.html#method__destruct">__destruct</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methoddebug">debug</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methoddelete">delete</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methoddo_fulllog">do_fulllog</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methoddo_log">do_log</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodfetch">fetch</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodfetch_col">fetch_col</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodfetch_query">fetch_query</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodfetch_row">fetch_row</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodfetch_search">fetch_search</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodfield_exists">field_exists</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodfix_list">fix_list</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodfix_sql">fix_sql</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodfix_where">fix_where</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodget_error">get_error</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodget_lastquery">get_lastquery</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodget_log">get_log</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodget_result">get_result</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodget_rows">get_rows</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodinsert">insert</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodkill">kill</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodlist_trim">list_trim</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodprintlog">printlog</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodquery">query</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodselectdb">selectdb</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodset_param">set_param</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodtimenow">timenow</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodtrack">track</a></li>
    <li><a href="../SimpleSQL/simplesql.html#methodupdate">update</a></li>
    <li><a href="../SimpleSQL/simplesql.html#method__call">__call</a></li>
    <li><a href="../SimpleSQL/simplesql.html#method__get">__get</a></li>
    <li><a href="../SimpleSQL/simplesql.html#method__set">__set</a></li>
  </ul>
</td>

</tr></table>
<hr />

<table width="100%" border="0"><tr>






</tr></table>
<hr />

<a name="class_details"></a>
<h3>Class Details</h3>
<div class="tags">
[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a37">37</a>]<br />
</div><br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />


<hr />
<a name="class_methods"></a>
<h3>Class Methods</h3>
<div class="tags">
  <hr />
	<a name="methodage"></a>
	<h3>method age <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a1291">1291</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>float age(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Age; how long the class has been alive<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>microtime</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>protected</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodconnect"></a>
	<h3>method connect <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a310">310</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean connect(
[boolean
$re = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Connect; connects to a database<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$re</b>&nbsp;&nbsp;</td>
        <td>Reconnect</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="method__construct"></a>
	<h3>constructor __construct <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a149">149</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void __construct(
[string
$db_host = NULL], [string
$db_user = NULL], [string
$db_pass = NULL], [string
$db_name = NULL], [int
$db_port = 3306], [string
$db_socket = ''])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Constructor; sets up connection varables and connects<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>private</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$db_host</b>&nbsp;&nbsp;</td>
        <td>Server</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$db_user</b>&nbsp;&nbsp;</td>
        <td>Username</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$db_pass</b>&nbsp;&nbsp;</td>
        <td>Password</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$db_name</b>&nbsp;&nbsp;</td>
        <td>Database Name</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$db_port</b>&nbsp;&nbsp;</td>
        <td>Database Port</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$db_socket</b>&nbsp;&nbsp;</td>
        <td>Database Socket</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="method__destruct"></a>
	<h3>destructor __destruct <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a203">203</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void __destruct(
boolean
$re)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Destruct; destroys connection and reports logs<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>private</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$re</b>&nbsp;&nbsp;</td>
        <td>Reconnect</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methoddebug"></a>
	<h3>method debug <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a898">898</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string debug(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Debug;<br /><br /><p>Not quite finished with this function. I plan to  make this function return a nice HTML layed out page  of all the logs, stored in raw file, and optomization solutions.</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methoddelete"></a>
	<h3>method delete <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a715">715</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean delete(
[mixed
$wfield = NULL], [boolean
$pass = false], [string
$table = NULL], [mixed
$limit = NULL])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Delete; Delete data from a table<br /><br /><p>Call this function with limit argument set to -1  to truncat the table.</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$wfield</b>&nbsp;&nbsp;</td>
        <td>Row that will be deleted</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$pass</b>&nbsp;&nbsp;</td>
        <td>A verification array, set it to true   if you are sure you do not want to add a limit to a no-where-clause   DELETE query</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$table</b>&nbsp;&nbsp;</td>
        <td>Table that will be used</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$limit</b>&nbsp;&nbsp;</td>
        <td>Limit the result to this number</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methoddo_fulllog"></a>
	<h3>method do_fulllog <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a1310">1310</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void do_fulllog(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Do_Log; Write full log array to a file<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methoddo_log"></a>
	<h3>method do_log <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a1339">1339</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void do_log(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Do_Log; Write log track array to a file<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodfetch"></a>
	<h3>method fetch <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a1207">1207</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>mixed fetch(
resource
$res, int
$fetch)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Fetch; Impliment the mysql_fetch_* functions<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>protected</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">resource&nbsp;&nbsp;</td>
        <td><b>$res</b>&nbsp;&nbsp;</td>
        <td>Query result</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$fetch</b>&nbsp;&nbsp;</td>
        <td>Fetch Type</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodfetch_col"></a>
	<h3>method fetch_col <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a476">476</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>mixed fetch_col(
[mixed
$field = NULL], [mixed
$table = NULL], [int
$fetch = NULL], [string
$order = NULL], [mixed
$limit = NULL])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Fetch_Col; Fetch (a) Coloumn(s) of data from the database<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$field</b>&nbsp;&nbsp;</td>
        <td>Field(s) that will be used</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$table</b>&nbsp;&nbsp;</td>
        <td>Table that will be used</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$fetch</b>&nbsp;&nbsp;</td>
        <td>Controls the result datatype</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$order</b>&nbsp;&nbsp;</td>
        <td>field to order by (append DESC if needed)</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$limit</b>&nbsp;&nbsp;</td>
        <td>Limit the result to this number</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodfetch_query"></a>
	<h3>method fetch_query <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a441">441</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>mixed fetch_query(
mixed
$query, [int
$fetch = NULL])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Fetch_Query; Send a query and fetch the results<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$query</b>&nbsp;&nbsp;</td>
        <td>Query that will be sent</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$fetch</b>&nbsp;&nbsp;</td>
        <td>Controls the result datatype</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodfetch_row"></a>
	<h3>method fetch_row <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a537">537</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>mixed fetch_row(
[mixed
$field = NULL], [mixed
$table = NULL], [int
$fetch = NULL], [string
$order = NULL], [mixed
$limit = NULL])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Fetch_Row; Fetch (a) Row(s) of data from the database<br /><br /><p>This function is nearly identical to Fetch Column but instead  this function will fetch all fields in the table instead of  the ones listed in the arguments. Also this function has all  optional arguments.</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$field</b>&nbsp;&nbsp;</td>
        <td>Field(s) that will be used</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$table</b>&nbsp;&nbsp;</td>
        <td>Table that will be used</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$fetch</b>&nbsp;&nbsp;</td>
        <td>Controls the result datatype (array or object)</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$order</b>&nbsp;&nbsp;</td>
        <td>field to order by (append DESC if needed)</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$limit</b>&nbsp;&nbsp;</td>
        <td>Limit the result to this number</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodfetch_search"></a>
	<h3>method fetch_search <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a588">588</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>mixed fetch_search(
string
$find, [mixed
$field = NULL], [mixed
$table = NULL], [int
$fetch = NULL], [string
$order = NULL], [mixed
$limit = NULL])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Fetch_Search; Fetch data bassed on a search pattern<br /><br /><p>This function will pass a regular expression string ($find)  to the fix_sql private function.</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$find</b>&nbsp;&nbsp;</td>
        <td>The varable that will be found in the DB (regexp)</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$field</b>&nbsp;&nbsp;</td>
        <td>Field(s) that will be used</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$table</b>&nbsp;&nbsp;</td>
        <td>Table that will be used</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$fetch</b>&nbsp;&nbsp;</td>
        <td>Controls the result datatype (array or object)</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$order</b>&nbsp;&nbsp;</td>
        <td>field to order by (append DESC if needed)</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$limit</b>&nbsp;&nbsp;</td>
        <td>Limit the result to this number</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodfield_exists"></a>
	<h3>method field_exists <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a912">912</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean field_exists(
string
$field, [string
$table = NULL])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Field_Exists; See if field exists in givin table<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$field</b>&nbsp;&nbsp;</td>
        <td>Field to be found</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$table</b>&nbsp;&nbsp;</td>
        <td>Table that will be searched</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodfix_list"></a>
	<h3>method fix_list <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a1148">1148</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>array fix_list(
string
$list)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Fix_List; Return an array of broken elements from a list  seperated by commas and quotes<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>protected</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$list</b>&nbsp;&nbsp;</td>
        <td>List to be converted to array</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodfix_sql"></a>
	<h3>method fix_sql <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a985">985</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string fix_sql(
array
$sql, [mixed
$Extra = NULL], string
$type)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Fix_Sql; Fix the SQL array and return a queryable string<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>The long do statment in the fields case simply strips the field  string into an array and then makes a where clause if needed</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>protected</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">array&nbsp;&nbsp;</td>
        <td><b>$sql</b>&nbsp;&nbsp;</td>
        <td>SQL array</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$type</b>&nbsp;&nbsp;</td>
        <td>Type of fetch</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodfix_where"></a>
	<h3>method fix_where <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a1125">1125</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string fix_where(
string
$field)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Fix_Where; Return a where clause with proper MySQL syntax<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>protected</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$field</b>&nbsp;&nbsp;</td>
        <td>Field that will be included in where clause</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodget_error"></a>
	<h3>method get_error <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a882">882</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>mixed get_error(
[boolean
$full = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get_Error; Return the last error (default) or if the first  argument set to true then it will return the full error array<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$full</b>&nbsp;&nbsp;</td>
        <td>Return the full array (default false)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodget_lastquery"></a>
	<h3>method get_lastquery <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a829">829</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string get_lastquery(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get_LastQuery; return string of the last executed query<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodget_log"></a>
	<h3>method get_log <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a868">868</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>array get_log(
[string
$key = NULL])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get_Log; return result from last SELECT query<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$key</b>&nbsp;&nbsp;</td>
        <td>If provided, function will return array of  only the key given. track, mysql, session, etc..</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodget_result"></a>
	<h3>method get_result <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a842">842</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>mixed get_result(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get_Result; return result from last SELECT query<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodget_rows"></a>
	<h3>method get_rows <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a854">854</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>int get_rows(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get_Rows; return num rows from last SELECT query<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodinsert"></a>
	<h3>method insert <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a643">643</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean insert(
mixed
$fields, mixed
$values, [string
$table = NULL])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Insert; Insert data into a table<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$fields</b>&nbsp;&nbsp;</td>
        <td>Field(s) that will inserted data</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$values</b>&nbsp;&nbsp;</td>
        <td>Value(s) that will be inserted</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$table</b>&nbsp;&nbsp;</td>
        <td>Table that will be used</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodkill"></a>
	<h3>method kill <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a1251">1251</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void kill(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Kill; Disconnect from database<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>private</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodlist_trim"></a>
	<h3>method list_trim <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a1237">1237</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string list_trim(
string
&$str, [mixed
$tpat = ', '])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		List_Trim; Trim the end of a list from a loop<br /><br /><p>Function will take out extra ', ' on the end of a list string</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>protected</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>&$str</b>&nbsp;&nbsp;</td>
        <td>String to trim</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodprintlog"></a>
	<h3>method printlog <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a1379">1379</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void printlog(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		PrintLog; Print the log array to the screen<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodquery"></a>
	<h3>method query <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a352">352</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>resource query(
string
$query)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Query; Sends query to database<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$query</b>&nbsp;&nbsp;</td>
        <td>Query String</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodselectdb"></a>
	<h3>method selectdb <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a289">289</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean selectdb(
string
$db, resouce
$conn)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		SelectDB; Selects the database<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$db</b>&nbsp;&nbsp;</td>
        <td>Database to select</td>
      </tr>
          <tr>
        <td class="type">resouce&nbsp;&nbsp;</td>
        <td><b>$conn</b>&nbsp;&nbsp;</td>
        <td>conection resource</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodset_param"></a>
	<h3>method set_param <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a1185">1185</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void set_param(
string
&$arg, string
$name)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set_Param; Set an argument value if already exists<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>private</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>&$arg</b>&nbsp;&nbsp;</td>
        <td>Argument varable</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$name</b>&nbsp;&nbsp;</td>
        <td>Argument name</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodtimenow"></a>
	<h3>method timenow <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a1270">1270</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>float timenow(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		TimeNow; returns the current time<br /><br /><p>In PHP 5, microtime() was givin a boolean  param, if true, microtime() would return a float  which is exactly what this function does.</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>protected</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodtrack"></a>
	<h3>method track <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a952">952</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void track(
string
$type, string
$from, string
$msg, [string
$error = ''], [mixed
$age = ''])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Track; Build log array<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>private</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$type</b>&nbsp;&nbsp;</td>
        <td>Type of entry</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$from</b>&nbsp;&nbsp;</td>
        <td>Function orgin</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$msg</b>&nbsp;&nbsp;</td>
        <td>Message</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$error</b>&nbsp;&nbsp;</td>
        <td>Server error message</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodupdate"></a>
	<h3>method update <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a761">761</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean update(
mixed
$fields, mixed
$values, [string
$wfields = NULL], [string
$table = NULL], [mixed
$limit = NULL])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Update; Update data in a table<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$fields</b>&nbsp;&nbsp;</td>
        <td>Field(s) that will be changed</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$values</b>&nbsp;&nbsp;</td>
        <td>Value(s) that will be assigned</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$wfields</b>&nbsp;&nbsp;</td>
        <td>Where fields clause</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$table</b>&nbsp;&nbsp;</td>
        <td>Table that will be used</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$limit</b>&nbsp;&nbsp;</td>
        <td>Limit the result to this number</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="method__call"></a>
	<h3>method __call <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a230">230</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void __call(
string
$m)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Call; Picks up any undeclaired methods<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>private</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$m</b>&nbsp;&nbsp;</td>
        <td>Method called</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="method__get"></a>
	<h3>method __get <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a246">246</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>mixed __get(
string
$var)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get; Get a variable's value<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>private</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$var</b>&nbsp;&nbsp;</td>
        <td>variable</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="method__set"></a>
	<h3>method __set <span class="smalllinenumber">[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a268">268</a>]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void __set(
string
$var, string
$val)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set; Set a variable's value<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>private</td>
  </tr>
  <tr>
    <td><b>author:</b>&nbsp;&nbsp;</td><td>Paul Williamson &lt;<a href="mailto:webmaster@protonage.net">webmaster@protonage.net</a>&gt;</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$var</b>&nbsp;&nbsp;</td>
        <td>variable</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$val</b>&nbsp;&nbsp;</td>
        <td>value to be assigned</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
</div><br />

<hr />
<a name="class_constss"></a>
<h3>Class Constants</h3>
<div class="tags">
	<a name="constDATE_FORMAT"></a>
	<p></p>
	<h4>DATE_FORMAT = <span class="value">&nbsp;'F&nbsp;jS,&nbsp;Y,&nbsp;H:i:s&nbsp;T'</span></h4>
	<p>[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a51">51</a>]</p>
  
  <br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="constLOG_PATH"></a>
	<p></p>
	<h4>LOG_PATH = <span class="value">&nbsp;'.'</span></h4>
	<p>[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a49">49</a>]</p>
  
  <br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="constMAX_SIZE"></a>
	<p></p>
	<h4>MAX_SIZE = <span class="value">&nbsp;2000000</span></h4>
	<p>[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a50">50</a>]</p>
  
  <br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="constVERSION"></a>
	<p></p>
	<h4>VERSION = <span class="value">&nbsp;'SimpleSQL&nbsp;v2.0.1&nbsp;PHP5'</span></h4>
	<p>[line <a href="..//__filesource/fsource_SimpleSQL__simplesql.php.html#a48">48</a>]</p>
  Constants;<br /><br /><p>VERSION; SimpleSQL Version                  @const string  LOG_PATH; Path to logs                      @const string  MAX_SIZE; Max size of log file              @const int  DATE_FORMAT; Date Format for Log            @const string</p><br />
  <br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
</div><br />

        <div class="credit">
		    <hr />
		    Documentation generated on Mon, 30 Aug 2004 12:39:44 -0600 by <a href="http://www.phpdoc.org">phpDocumentor 1.3.0RC3</a>
	      </div>
      </td></tr></table>
    </td>
  </tr>
</table>

</body>
</html>